1.myisamchk Method of Invocation
myisamchk [Options] tbl_name ...
Where options specify what you want Myisamchk to do.
It allows you to use the mode "*. Myi "Specifies all the tables in a directory.
Shell> Myisamchk *. Myi
The recommended way to
1. Call method of myisamchk
Myisamchk [Options] tbl_name...
Options specifies what you want myisamchk to do.
It allows you to specify all tables in a directory by using the "*. myi" mode.Shell> myisamchk *. myi
We recommend that you quickly
1. Call method of myisamchkMyisamchk [options] tbl_name...Options specifies what you want myisamchk to do.It allows you to specify all tables in a directory by using the "*. MYI" mode.Shell> myisamchk *. MYIWe recommend that you quickly check all
Make MySQL datasheet healthier with myisamchk 2011-03-15 09:15 The water is too deep itpubfont Size:T | T In order for the data tables in the MySQL database to be "healthier", they need to undergo regular medical examinations. Here the author
Posted on December and 2009 by Axl MyISAM is MySQL's preset storage engine. MyISAM table is very easy to rot away (corrupted).This article will teach you how to check/fix these rotten MyISAM tables.
Every time you make a table in MySQL DB, you will
Instance
The code is as follows
Copy Code
#locate Myisamchk#ln-S/usr/local/mysql/bin/myisamchk/usr/bin/myisamchk#myisamchk TableName. Myi#myisamchk-R-Q tablename
If-R does not use the enforcement command as
If a problem occurs in the database or data table in mysql, we can use the myisamchk command to modify it. Next I will introduce the usage of the myisamchk command.
Instance
The Code is as follows:
Copy code
# Locate
The file format used by MySQL to store data has been widely tested, but there are always external conditions that can cause damage to the database table:
The mysqld process is killed in a write; the computer is accidentally shut down (for example,
Description, check and repair of MyISAM tables.Used without options all tables on the command would be a checked for errorsUsage:myisamchk [OPTIONS] tables[. MYI] Global Options: -H,--help display this Help and exit. -?,--help display this help and
Method One, modify directly in command mode
1, Myisamchk
To fix the MySQL database, there is also a command: Mysqlcheck
Mysqlcheck-a-c-o-r–all-databases-uroot-p//This command is the best way to optimize all DB databases.
The meaning of the
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.